package org.dromara.yuanshidian.domain.vo;

import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
import org.dromara.yuanshidian.domain.Ab02New;
import com.alibaba.excel.annotation.ExcelIgnoreUnannotated;
import com.alibaba.excel.annotation.ExcelProperty;
import org.dromara.common.excel.annotation.ExcelDictFormat;
import org.dromara.common.excel.convert.ExcelDictConvert;
import io.github.linpeilie.annotations.AutoMapper;
import lombok.Data;

import java.io.Serial;
import java.io.Serializable;
import java.util.Date;



/**
 * 新在职人员信息视图对象 ab02_new
 *
 * @author TzhongTop
 * @date 2025-01-24
 */
@Data
@ExcelIgnoreUnannotated
@AutoMapper(target = Ab02New.class)
public class Ab02NewVo implements Serializable {

    @Serial
    private static final long serialVersionUID = 1L;

    /**
     * 主键ID
     */
    @ExcelProperty(value = "主键ID")
    private Long id;

    /**
     * 统筹区编码
     */
    @ExcelProperty(value = "统筹区编码")
    private String aaa027;

    /**
     *
     */
    @ExcelProperty(value = "")
    private String dwh;

    /**
     * 原编号
     */
    @ExcelProperty(value = "原编号")
    private String grbh;

    /**
     *
     */
    @ExcelProperty(value = "")
    private Long gr00;

    /**
     * 单位编码
     */
    @ExcelProperty(value = "单位编码")
    private String dw01;

    /**
     * 单位名称
     */
    @ExcelProperty(value = "单位名称")
    private String dw02;

    /**
     *
     */
    @ExcelProperty(value = "")
    private String bh;

    /**
     *
     */
    @ExcelProperty(value = "")
    private Long grid;

    /**
     * 个人编号
     */
    @ExcelProperty(value = "个人编号")
    private String gr01;

    /**
     * 身份证号码
     */
    @ExcelProperty(value = "身份证号码")
    private String gr02;

    /**
     * 个人帐号
     */
    @ExcelProperty(value = "个人帐号")
    private String gr03;

    /**
     * 职工姓名
     */
    @ExcelProperty(value = "职工姓名")
    private String gr04;

    /**
     * 性别
     */
    @ExcelProperty(value = "性别")
    private String gr05;

    /**
     * 民族
     */
    @ExcelProperty(value = "民族")
    private String gr06;

    /**
     * 出生时间
     */
    @ExcelProperty(value = "出生时间")
    private Date gr07;

    /**
     * 工作时间
     */
    @ExcelProperty(value = "工作时间")
    private Date gr08;

    /**
     * 职工身份
     */
    @ExcelProperty(value = "职工身份")
    private String gr09;

    /**
     * 建立帐户时间
     */
    @ExcelProperty(value = "建立帐户时间")
    private Date gr10;

    /**
     * 计算值
     */
    @ExcelProperty(value = "计算值")
    private Long gr11a;

    /**
     * 调整值
     */
    @ExcelProperty(value = "调整值")
    private Long gr11b;

    /**
     * 视同
     */
    @ExcelProperty(value = "视同")
    private Long gr11;

    /**
     * 统筹开始时间
     */
    @ExcelProperty(value = "统筹开始时间")
    private Date gr12;

    /**
     * 统筹结束时间
     */
    @ExcelProperty(value = "统筹结束时间")
    private Date gr13;

    /**
     * 统筹缴费月
     */
    @ExcelProperty(value = "统筹缴费月")
    private Long gr14;

    /**
     * 统筹缴费总额
     */
    @ExcelProperty(value = "统筹缴费总额")
    private Long gr15;

    /**
     * 统筹单位缴费额
     */
    @ExcelProperty(value = "统筹单位缴费额")
    private Long gr16;

    /**
     * 统筹个人缴费额
     */
    @ExcelProperty(value = "统筹个人缴费额")
    private Long gr17;

    /**
     * 实际工资
     */
    @ExcelProperty(value = "实际工资")
    private Long gr18;

    /**
     * 缴费基数
     */
    @ExcelProperty(value = "缴费基数")
    private Long gr19;

    /**
     * 个人缴费额
     */
    @ExcelProperty(value = "个人缴费额")
    private Long gr20;

    /**
     * 94调标工资
     */
    @ExcelProperty(value = "94调标工资")
    private Long gr21;

    /**
     *
     */
    @ExcelProperty(value = "")
    private Long gr210;

    /**
     *
     */
    @ExcelProperty(value = "")
    private Long gr211;

    /**
     *
     */
    @ExcelProperty(value = "")
    private Long gr212;

    /**
     *
     */
    @ExcelProperty(value = "")
    private Long gr213;

    /**
     *
     */
    @ExcelProperty(value = "")
    private Long gr214;

    /**
     * 状态
     */
    @ExcelProperty(value = "状态")
    private String gr22;

    /**
     * 异动原因
     */
    @ExcelProperty(value = "异动原因")
    private String gr23;

    /**
     * 异动月份
     */
    @ExcelProperty(value = "异动月份")
    private String yd03;

    /**
     * 记帐月份
     */
    @ExcelProperty(value = "记帐月份")
    private String yd08;

    /**
     * 异动时补(退)额
     */
    @ExcelProperty(value = "异动时补(退)额")
    private Long yd10;

    /**
     * 补(退)标志
     */
    @ExcelProperty(value = "补(退)标志")
    private String yd11;

    /**
     * 其中单位补(退)
     */
    @ExcelProperty(value = "其中单位补(退)")
    private Long yd12;

    /**
     * 新工资
     */
    @ExcelProperty(value = "新工资")
    private Long gr24;

    /**
     * 调出单位编码
     */
    @ExcelProperty(value = "调出单位编码")
    private String gr26;

    /**
     * 补充额标准
     */
    @ExcelProperty(value = "补充额标准")
    private Long gr50;

    /**
     * 储蓄额标准
     */
    @ExcelProperty(value = "储蓄额标准")
    private Long gr51;

    /**
     * 本次补充额
     */
    @ExcelProperty(value = "本次补充额")
    private Long gr52;

    /**
     * 本次储蓄额
     */
    @ExcelProperty(value = "本次储蓄额")
    private Long gr53;

    /**
     *
     */
    @ExcelProperty(value = "")
    private String gr55;

    /**
     *
     */
    @ExcelProperty(value = "")
    private Long gr57;

    /**
     * 折算工龄
     */
    @ExcelProperty(value = "折算工龄")
    private Long gr60;

    /**
     *
     */
    @ExcelProperty(value = "")
    private String ed;

    /**
     *
     */
    @ExcelProperty(value = "")
    private String edlp;

    /**
     *
     */
    @ExcelProperty(value = "")
    private Long edsj;

    /**
     * 操作员
     */
    @ExcelProperty(value = "操作员")
    private String dw24;

    /**
     * 系统时间
     */
    @ExcelProperty(value = "系统时间")
    private Date systime;

    /**
     * 通讯地址
     */
    @ExcelProperty(value = "通讯地址")
    private String tx52;

    /**
     * 联系电话
     */
    @ExcelProperty(value = "联系电话")
    private String tx57;

    /**
     * 邮政编码
     */
    @ExcelProperty(value = "邮政编码")
    private String tx58;

    /**
     *
     */
    @ExcelProperty(value = "")
    private String pass;

    /**
     *
     */
    @ExcelProperty(value = "")
    private String gr61;

    /**
     *
     */
    @ExcelProperty(value = "")
    private String gr25;

    /**
     *
     */
    @ExcelProperty(value = "")
    private Long gr18a;

    /**
     *
     */
    @ExcelProperty(value = "")
    private Long gr19a;

    /**
     *
     */
    @ExcelProperty(value = "")
    private Long gr24a;

    /**
     *
     */
    @ExcelProperty(value = "")
    private String sfbj;

    /**
     *
     */
    @ExcelProperty(value = "")
    private String tzqsy;

    /**
     *
     */
    @ExcelProperty(value = "")
    private String bz;

    /**
     *
     */
    @ExcelProperty(value = "")
    private String tz01;

    /**
     * 转入金额
     */
    @ExcelProperty(value = "转入金额")
    private Long zrAmount;

    /**
     * 人员类型：1在职人员，2离退人员，3异动人员
     */
    @ExcelProperty(value = "人员类型：1在职人员，2离退人员，3异动人员")
    private Long ryType;

    /**
     * 异动类型：1转入，2补缴
     */
    @ExcelProperty(value = "异动类型",converter = ExcelDictConvert.class)
    @ExcelDictFormat(readConverterExp = "1=转入,2=补缴")
    private Long ydType;

    /**
     * 转入开始月份
     */
    @ExcelProperty(value = "转入开始月份")
    private Date zrStartmonth;

    /**
     * 转入截至月份
     */
    @ExcelProperty(value = "转入截至月份")
    private Date zrEndmonth;

    /**
     * 数据状态:1待提交2审核中3已审核4驳回
     */
    @ExcelProperty(value = "数据状态:1待提交2审核中3已审核4驳回")
    private Long status;

    /**
     * 删除状态:0未删除，1已删除
     */
    @ExcelProperty(value = "删除状态:0未删除，1已删除")
    private Long delStatus;

    /**
     * 退费状态：0未退费，1已退费
     */
    @ExcelProperty(value = "退费状态：0未退费，1已退费")
    private Long refStatus;

    /**
     * 文件地址
     */
    @ExcelProperty(value = "文件地址")
    private String fileurl;

    /**
     * 单个上传确认表附件
     */
    @ExcelProperty(value = "单个上传确认表附件")
    private String tableflieurl;


}
